Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
TransactionID (FK)(PK) | A universally unique identifier (UUID) for the parent TenderControlTransaction | ID_TRN | IdentityUUID | char(32) | TenderControlTransaction(TR_CTL_TND) |
LineItemID (PK) | A sequence numer used to identify unique line item instances within a TenderControlTransaction. | IC_LN_ITM | LineNumber | smallint | |
TenderTypeCode (FK)(PK) | A code which uniquely identifies the type of tender being moved in the TenderControlTransaction. | TY_TND | Code | varchar(20) | Tender(AS_TND) |
DenominationID (FK) | An identifier which uniquely identifies the quantitative value of a specific currency, e.g. $100, �50, being moved. Because currency detail is identified by tender type, currency AND denomination, we are adding CurrencyID and Denominator to the primary key for this entity. WIthout these, the entity's unique ID is not adequate to handle detailed tender counts which is part of Tender Control. | ID_DNM | Identity | integer | Denomination(CO_DNM) |
ForeignCurrencyAmount | The monetary value (in currency being moved) of the Tender being moved by the transaction. | MO_FRG_CY | MoneyShortRetail | decimal(7,2) | |
Amount | The monetary value (in the default system currency) of the Tender being moved by the transaction. | MO_TND_FN_TRN | Money | decimal(16,5) | |
Count | The number of tender units being moved. eg 20x$100 bills. | QU_TND_FN_TRN | QuantityTransactionCount | decimal(7,0) | |
ISOCurrencyCode (FK) | Currency code designated by ISO to identify national currency | CD_CNY_ISO_4217 | ISO_4217_CurrencyCode_char(3) | char(3) | Denomination(CO_DNM) |